CREATE procedure [dbo].[BAEEventSetupAddGeneralInfo] @eventCode varchar(15),
     @cutOffDate datetime,
     @cutoffMessage varchar(256),
     @registrantClass varchar(24),
     @storedProc varchar(64),
     @RegisterSomeoneElse bit,
     @permanentChange bit as
SELECT * FROM EventSetupGeneral where EventCode = @eventCode;
      IF(@@RowCount > 0)
            BEGIN
                  UPDATE EventSetupGeneral
                        SET OnlineCutOffDate = @cutOffDate, OnlineCutOffMessage = @cutoffMessage, RegistrantClassType = @registrantClass,
                              RegistrantClassStoredProcedure = @storedProc, RegisterSomeoneElseOption = @RegisterSomeoneElse, PermanentChange = @permanentChange      
                  WHERE EventCode = @eventCode;
            END
      ELSE
            BEGIN
                  IF(@storedProc = '')
                        BEGIN
                              INSERT INTO EventSetupGeneral(EventCode, OnlineCutOffDate, OnlineCutOffMessage, RegistrantClassType,
                                    RegistrantClassStoredProcedure, RegisterSomeoneElseOption, PermanentChange)
                              VALUES(@eventCode, @cutOffDate, @cutoffMessage, @registrantClass, NULL, @RegisterSomeoneElse, @permanentChange);
                        END
                  ELSE
                        BEGIN
                              INSERT INTO EventSetupGeneral(EventCode, OnlineCutOffDate, OnlineCutOffMessage, RegistrantClassType,
                                    RegistrantClassStoredProcedure, RegisterSomeoneElseOption, PermanentChange)
                              VALUES(@eventCode, @cutOffDate, @cutoffMessage, @registrantClass,@storedProc, @RegisterSomeoneElse, @permanentChange);
                        END
            END

GO